You are here : Administrator Tools > System Policies > Inventory Policy

Inventory Policy

 

Every organization has its own unique way of functioning. Through this option, users can instruct IMMS to behave in a particular manner to suit the functioning of the organization. In technical jargon this process is known as setting the flags. Hence, setting the flag as YES or NO to certain options, determines the behaviour of IMMS.

 

It is very important for the user to know the implications of setting the flag in a particular position. Administrator/User, after taking inputs from all the concerned, needs to take an informed decision before setting the flag in a particular position. Positions of some flags cannot be changed during the year.

 

Through this option, user can define parameters which influence many important matters related to the Stores department. They affect many entries and reports of the Stores & Inventory Module.

 

Click on the button to enter/change the values of the flags.

Screen Layout of Inventory Policy

Field Description of Inventory Policy

Default Inventory Valuation Method:

Select one of the following options from the provided popup.

 

Description:

 

Following three Inventory Valuation Methods are available in IMMS. The valuation method is applied after issues are done by stores.

 

1) FIFO (First In First Out)

As the name suggests, materials that have come first in the stores will be issued first. The valuation of inventory after issues for remaining material in stores is called FIFO inventory valuation method. CollapsedExample.

 

Suppose opening balance of Item 'xyz' in stores is zero.

 

First lot of 10 quantities of Item 'xyz' is received in stores at the rate of Rupees 10 per item on 1st April 2011.

 

Second lot of 10 quantities of item 'xyz' is received in stores at the rate of Rupees 15 per item on 5th May 2011.

 

Third lot of 10 quantities of item 'xyz' is received in stores at the rate of Rupees 20 per item on 8th June 2011.

 

Now if a company adopts the FIFO method and if there are 10 quantities of item 'xyz' to be issued to production department by stores then those items that have arrived first in stores will be issued. Hence, those 10 item that were received on 1st April 2011 at Rupees 10 per item will be issued to production department from stores. Therefore, according to FIFO method, inventory valuation will be as follows -

 

Total inventory valuation as per FIFO will be (10X15) + (10X20) = Rupees 350.

 

Also for costing purpose, material cost in production will be (10X10) = Rupees 100.

 

2) Weighted (Moving) Average

Materials in this case is issued from stores in a random fashion. Therefore it does not matter whether the material was received first or last, it is issued in any order. The valuation done for remaining material in store after issues is called Weighted Average method of inventory valuation.

 

3) At Cost (Actual)

Same Material can be received in the store with different quantities of dimensions/Serial No/Batch No/Inward No, at the same or different rate. Similarly while issuing, the quantity of the material for the specific dimension/Serial No/Batch No/Inward No only will be issued. The valuation of inventory after issues for the remaining same material irrespective of its dimensions/Serial No/Batch No/Inward No in stores is called At Cost (Actual) inventory valuation method.

Association of GRN and Gate Inward Entry Required?

Turn the flag 'On' or 'Off' by clicking on it.

 

If 'On' is chosen, a Goods Receipt Note can be generated against material received at the gate through Gate Inward Entry option of Store & Inventory Module.

 

If 'Off' is chosen, a Goods Receipt Note can be NOT be generated against a Gate Inward.

 

Do you want to allow one GRN against multiple PO of same Vendor?

Turn the flag 'On' or 'Off' by clicking on it.

 

If 'On' is chosen, a Goods Receipt Note can consist of multiple Purchase Orders from the same Vendor.

 

If 'Off' is chosen, a Goods Receipt Note can be generated against a single Purchase Order only. IMMS also provides an option to enter details of material received at the gate through Gate Inward Entry option of Store & Inventory Module.

 

% of Excess Quantity to be accepted at GRN against PO Ordered Qty for LBT Items:

(Type : Numeric, Length : 2.2)

 

Enter the value in percentage.

 

There are some items which are consumed in terms of their dimensions. IMMS has a special provision to maintain weight of an item by recording its density, dimensions and pieces. Some companies accept excess quantity of LBT Items against Purchase Orders. Through this field, IMMS provides a facility to define what percentage of LBT Items can be accepted in excess at the time of making a Goods Receipt Note. CollapsedExample...

If excess percentage for Dimension items is 5%. Also suppose a particular vendor is given a purchase order of 100 quantity of LBT items. Now at the time of generating Goods Receipt Note, the company will be allowed to accept up to 105 quantities of LBT items and not more than that.

Warehouse Code (Used for I-Config):

Select the Default Warehouse Code.

 

Pre requisite:

Warehouses should already be defined through Warehouse Master option in Stores & Inventory Module.

 

Click on the field to access a list of already existing Warehouses defined through Warehouse Master option in Stores & Inventory Module. Select the Warehouse from the list by clicking on it. Alternatively you can also enter the Warehouse Code. Press <TAB>.

 

Do you Require Gate Inward Entry?

Turn the flag 'On' or 'Off' by clicking on it. Please note that this field will be enabled only in case the flag 'Do you want to allow one GRN against multiple PO of same Vendor?' is set as 'Off'. Otherwise it will remain disabled.

 

If 'On' is selected, IMMS will provides an option to enter details of material received at the gate through Gate Inward Entry option of Store & Inventory Module.

 

If 'Off' is chosen, a Goods Receipt Note can be generated against multiple Purchase Order.

 

Do you want to allow Gate Inward Entry for Unauthorized PO also?

Please note that this option will be enabled only if the flag "Do you Require Gate Inward Entry?" is selected as 'Yes'. Otherwise, it will remain disabled.

 

Turn the flag 'On' or 'Off' by clicking on it.

 

If 'On' is selected, IMMS will allow to create Gate Inward Entry against unauthorized Purchase Orders along with authorized ones through Gate Inward Entry option of Store & Inventory Module.

 

If 'Off' is chosen, IMMS will allow to create Gate Inward Entry against authorized Purchase Orders only through Gate Inward Entry option of Store & Inventory Module.

 

Turn the flag 'On' or 'Off' by clicking on it.

Do you want to maintain GRN Final Print Count and Draft/Duplicate print option?

Turn the flag 'On' or 'Off' by clicking on it.

 

If 'On' is selected, than while printing a GRN through GRN Print option of Stores And Inventory Module, IMMS will provide the option to print out Draft and Final copies of the GRN with respective headings. Additionally it also keeps track of GRNs that have already been printed or have not been printed at all.

 

If 'Off' is chosen, no such option to print out Draft or Final copy is provided and IMMS does not keep track of printed or non-printed GRNs.

 

Do you require Process defined in Item Master for an Item?

This flag denotes whether or not the Process should be associated with an Item while defining it. Moreover, such Items will further be linked with Process Warehouses.

 

By default this flag is selected as 'Off'. You can change it to 'On'. As a result, Process can be specified with an Item while defining it through Item Master Basic Details - Entry tab in Materials Module. Apart from this, IMMS also allows to define Process Warehouses through Warehouse Master option of Stores & Inventory Module that store such Items.

 

Please note that once this flag is set to 'On', it is NOT possible to change it back to 'Off'.

 

Gate Inward Number and Date Required in GRN Entry?

Turn the flag 'On' or 'Off' by clicking on it.

 

If 'On' is selected, than IMMS allows to enter the Number and Date for Gate Inward while generating Goods Receipt Notes through GRN Entry option of Stores & Inventory Module as well as through GRN Entry option of Sub Contracting Module.

 

If 'Off' is chosen, the Gate Inward Date will not be displayed and accepted while generating a Goods Receipt Note.

 

Do you want to Validate Challan No w.r.t. Vendor Code+ Warehouse Code+Financial Year?

Turn the flag 'On' or 'Off' by clicking on it.

 

If 'On' is selected, than while entering Challan Number through GRN Entry option of Stores And Inventory Module, IMMS will check if that Challan Number has already been entered for the combination of Vendor Code + Warehouse Code + Financial Year. If it already exists, a grid with a list of all such GRNs where the same Challan Number has been entered will be displayed for the user's information. It is the user's decision whether to continue with the Challan Number or not.

 

If 'Off' is selected, than while entering Challan Number through GRN Entry option of Stores And Inventory Module, IMMS will check if that Challan Number is unique or not. If it already exists, a grid with a list of all such GRNs where the same Challan Number has been entered will be displayed for the user's information. It is the user's decision whether to continue with the Challan Number or not.

 

Cash Purchase Amount Limit to be considered on:

IMMS provides the facility to limit the value of Cash Purchase while generating Goods Receipt Notes through GRN WITHOUT PO option of Stores And Inventory module.

 

Through this option a user can specify whether the limit should be applied on the 'Basic Value' or on the 'Basic Value with Tax' of the GRN. Once entered, you can not change the value of this field in 'Edit' mode.

 

Select 'Basic Value' if the limit should be applied on the Basic Value of the GRN. Select 'Basic Value with Tax' if the limit should be applied on the Basic Value including the tax.

 

Cash Purchase GRN Limit:

(Type : Numeric, Length : 7)

 

IMMS provides the facility to limit the value of Cash Purchase while generating Goods Receipt Notes through GRN WITHOUT PO option of Stores And Inventory module.

 

Enter the maximum value of Cash Purchase that is allowed while receiving the goods through GRN WITHOUT PO option of Stores And Inventory module. The limit is applicable on either 'Basic Value' or on 'Basic Value with Tax' depending upon the setting of the above flag. If the value is more than the specified limit, IMMS will display an appropriate message and stop the user from saving the GRN.

 

Delivery Considering On:

Enter the number of days which when added to the GRN Date should be considered as the Delivery date for an Item. For example, if 5 is entered in this option and GRN Date of an Item is say 20/02/2016. So the Delivery for this Item will be considered up to 25/02/2016 (20/02/2016 + 5 days ). Number of days entered in this option is further used for Delivery Overdue Report in Purchase Module.

 

Do you want to add Recipe Master variant?

Turn the flag 'On' or 'Off' by clicking on it.

 

 

Whether to allow Negative Adjustment in WH with Excise Flag?

Turn the flag 'On' or 'Off' by clicking on it.

 

If 'On' is selected, IMM will allow to do Negative Adjustment of stock in Excisable Warehouses through Negative Material Adjustment Voucher option of Stores and Inventory Module.

 

If 'Off' is selected, IMM will NOT allow to do Negative Adjustment of stock in Excisable Warehouses through Negative Material Adjustment Voucher option of Stores and Inventory Module.

 

Do you want Item WH setting mandatory at the time of PO/PO Amendment Entry?

Turn the flag 'On' or 'Off' by clicking on it.

 

If 'On' is selected, than while selecting the Warehouse for Item in Purchase Order, IMMS will ensure that only those Warehouses are selected that have been associated with that Item through Warehouse Inventory option of Stores And Inventory Module.

 

If 'Off' is selected, than while selecting the Warehouse for Item in Purchase Order, it is NOT mandatory that the Warehouse should be associated with the Item. In this case any Warehouse can be selected by the user.

 

Want to Consider Pending PO Qty in Kardex report?

Turn the flag 'On' or 'Off' by clicking on it.

 

If 'On' is selected, the Kardex Reports in Stores And Inventory Module will also display Purchase Order details for the selected Item(s) for which some purchase quantity is still pending to be received. The system will display both Authorized as well as un-Authorized Purchase Orders and their respective Pending Quantity will be displayed under the heading 'Credit (Inward) Qty' of the report. Also please note that since these quantities are not actually received in Warehouses, they will not be considered while calculating Balance Quantity.

 

If 'Off' is selected, Purchase Order details will not be considered in the report.

 

Do you want system Date and Time in Gate Inward/Outward Entry and not changeable?

Turn the flag 'On' or 'Off' by clicking on it.

 

If 'On' is selected, the system will display the current Date and Time in Gate Inward Entry option of Stores and Inventory Module and Gate Outward Entry option of Sales Module. The users will NOT be able to change them.

 

If 'Off' is selected, the system will still show the current Date and Time but the users will be able to change them.

 

In Positive Adjustment which default rate should be displayed?

IMMS provides the facility to select the type of an Item's Rate while creating its Positive Adjustment through Positive Material Adjustment Voucher option of Stores and Inventory Module.

As per Item class's Inventory method

Select this option by clicking on it if you want to consider the Rate as per the Items Class's Inventory Valuation Method mentioned through Class/Sub-Class Master option.

 

Last GRN Rate in any WH of Adj. Site

Select this option by clicking on it if you want to consider the Rate mentioned in the last GRN of the Item in any Warehouse of the Adjustment Site.

 

Default Vendor Rate from Item Vendor

Select this option by clicking on it if you want to consider the Rate of the Item mentioned for its default Vendor through Item Vendor Purchase Master Entry option of Purchase Module.

Do you want to use KANBAN functionality?

This flag allows to activate KANBAN functionality in IMMS. By default it is selected as 'Off'. You can change it to 'On' if KANBAN functionality has to be used. In that case, to start with, the user is asked to provide certain information such as KANBAN Warehouses or whether a particular Item is a KANBAN Item or not and many more.

 

Please note that once this flag is set to 'On', it is NOT possible to change it back to 'No'. Please contact Sourcepro Infotech Pvt. Ltd. if such a need arises.

 

Main Warehouse Code for KANBAN:

Please note that this field will be enabled only if the flag 'Do you want to use KANBAN functionality?' is set as 'On'. Otherwise it will remain disabled.

 

Denotes the default main Warehouse from where the KANBAN Items will be transferred to their respective KANBAN Warehouses.

 

Click on the field to access a list of Warehouses defined through Warehouse Master option of Stores & Inventory Module. Select your desired Warehouse from the list by clicking on it. Alternatively you can also enter the Warehouse Code. Press <TAB>.

 

Please note that this Warehouse is specifically a Non KANBAN Warehouse. And therefore, none of the KANBAN Warehouses will be displayed/accepted here.

 

KANBAN Positive Adjustment Group Code:

Please note that this field will be enabled only if the flag 'Do you want to use KANBAN functionality?' is set as 'On'. Otherwise it will remain disabled.

 

During the execution of a Work Order, if the required quantity of a KANBAN Item is not available or falls short in the respective Work Order KANBAN Warehouse, IMMS will automatically generate a Positive Adjustment Voucher to replenish the required quantity and allocate them.

 

This field denotes the default Group Code under which Positive Adjustment of KANBAN Items into respective Work Order KANBAN Warehouse will be generated automatically whenever needed.

 

Click on the field to access a list of already defined Positive Adjustment Groups for the entered Year though Document Control Master option in Administrator Tools Module . Select your desired Group from the list by clicking on it. Alternatively you can also enter the Group Code.

 

KANBAN Positive Adjustment Prepared By:

Please note that this field will be enabled only if the flag 'Do you want to use KANBAN functionality?' is set as 'On'. Otherwise it will remain disabled.

 

Denotes the default User under whose name the automatically generated Positive Adjustment Voucher will be prepared.

 

Click on the field to access a list of already defined Users though User Management option. Select your desired User from the list by clicking on it. Alternatively you can also enter the User Code.

 

KANBAN Positive Adjustment Authorized By:

Please note that this field will be enabled only if the flag 'Do you want to use KANBAN functionality?' is set as 'On'. Otherwise it will remain disabled.

 

Denotes the default User under whose name the automatically generated Positive Adjustment Voucher will be authorized.

 

Click on the field to access a list of already defined Users though User Management option. Select your desired User from the list by clicking on it. Alternatively you can also enter the User Code.

 

KANBAN Issue Group Code:

Please note that this field will be enabled only if the flag 'Do you want to use KANBAN functionality?' is set as 'On'. Otherwise it will remain disabled.

 

Once the required quantity of KANBAN Items is allocated from the available in-hand quantity to the respective Work Order KANBAN Warehouse, IMMS will automatically Issue them by generating the Issue Note.

 

This field denotes the default Group Code under which Issue Notes will be generated automatically whenever needed.

 

Click on the field to access a list of already defined Issue Groups for the entered Year though Document Control Master option in Administrator Tools Module . Select your desired Group from the list by clicking on it. Alternatively you can also enter the Group Code.

 

KANBAN Issue To:

Please note that this field will be enabled only if the flag 'Do you want to use KANBAN functionality?' is set as 'On'. Otherwise it will remain disabled.

 

Denotes the default Employee to whom the material will be Issue to through automatically generated Issue Note.

 

Click on the field to access a list of already defined Employees though Employee Masteroption. Select your desired Employee from the list by clicking on it. Alternatively you can also enter the Employee Code.

 

KANBAN Issue By:

Please note that this field will be enabled only if the flag 'Do you want to use KANBAN functionality?' is set as 'On'. Otherwise it will remain disabled.

 

Denotes the default Employee by whom the material will be Issued through automatically generated Issue Note.

 

Press <F5> key to access a list of already defined Employees though Employee Masteroption. Select your desired Employee from the list by scrolling down to it and pressing <ENTER>. Alternatively you can also enter the Employee Code.

 

KANBAN Issue Authorized By:

Please note that this field will be enabled only if the flag 'Do you want to use KANBAN functionality?' is set as 'Yes'. Otherwise it will remain disabled.

 

Denotes the default Employee under whose name the automatically generated Issue Note will be authorized.

 

Click on the field to access a list of already defined Employees though Employee Masteroption. Select your desired Employee from the list by clicking on it. Alternatively you can also enter the Employee Code.

 

Default Reason (Adjustment):

Please note that this field will be enabled only if the flag 'Do you want to use KANBAN functionality?' is set as 'On'. Otherwise it will remain disabled.

 

This is the default Reason that will be allocated to the Positive Adjustment Voucher that is generated automatically by IMMS during Work Order Receipt involving a KANBAN Child Item.

Click on the field to access a list of already defined Reasons though Codes Master (Code Type='RC'option. Select your desired Reason from the list by clicking on it. Alternatively you can also enter the Reason Code.

BackFlush Issue Group Code:

Denotes the Default Group Code for BackFlush Issue.

 

Click on the field to access a list of already defined Issue Groups for the entered Year though Document Control Master option in Administrator Tools Module . Select your desired Group from the list by clicking on it. Alternatively you can also enter the Group Code.

 

BackFlush Issue To:

Denotes the Employee to whom BackFlush is Issued.

 

Click on the field to access a list of already defined Employees defined though Employee Master option in Administrator Tools Module. Select your desired Employee from the list by clicking on it. Alternatively you can also enter the Employee Code.

 

BackFlush Issue By:

Denotes the Employee who has issued the BackFlush.

 

Click on the field to access a list of already defined Employees defined though Employee Master option in Administrator Tools Module. Select your desired Employee from the list by clicking on it. Alternatively you can also enter the Employee Code.

 

BackFlush Issue Authorized By:

Denotes the Employee who will authorize the BackFlush.

 

Click on the field to access a list of already defined Employees defined though Employee Master option in Administrator Tools Module. Select your desired Employee from the list by clicking on it. Alternatively you can also enter the Employee Code.

 

Once you have entered all the information, click on 'Save' button to save or 'Cancel' button to discard.